<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
Design by Free CSS Templates
http://www.freecsstemplates.org
Released for free under a Creative Commons Attribution 2.5 License

Name       : Beach Sunset
Description: A two-column, fixed-width design for 1024x768 screen resolutions.
Version    : 1.0
Released   : 20090416

-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>EliminarReservacion</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
<style type="text/css">
<!--
.Estilo1 {font-size: 36px ; color: #FFFFFF}
.Estilo2 {
	color: #FFFFFF;
	font-size: 14px;
}

-->
</style>

</head>
<body>
<div id="wrapper">

	<div id="header">	
 		<br />
		<div id="menu">	  
				<li  class="active"><a href="HOME.php" title="HOME">HOME</a></li>
				<li><a href="INSERTAR.php" title="INSERTA">INSERTAR</a></li>
				<li><a href="ELIMINAR.php" title="ELIMINAR">ELIMINAR</a></li>
				<li><a href="CONSULTAR.php" title="CONSULTAR">CONSULTAR</a></li>
				<li><a href="MODIFICAR.php" title="MODIFICAR">MODIFICAR</a></li>
	  	</div>  <!-- end #menu -->			  
	
		<div id="search">
			<div id="menu">
					<li><a href="MOSTRAR.php" title="MOSTRAR">MOSTRAR</a></li>				
			</div> <!-- end #menu -->
		</div> <!-- end #search -->
	</div>    <!-- end #header -->				
	
	<div id="logo">
			<h2 class="Estilo1">Eliminar  </h2>
		    <div align="left"></div>
	</div> 	<!-- end #logo -->  
	
</div> <!-- end *header- wrapper -->
	
<hr />
<div id="page"><!-- end #content -->
  <!-- end #sidebar -->
  
    <p>&nbsp;</p>
  <p align="center" class="Estilo2">Seleccione la Reservacion a Eliminar
  <form action="EliminarReservacionDatos.php" method="post" id="form1">
    <div align="center">
    <table width="200" border="1">
  <tr>
    <td><span class="Estilo2">Servicio</span></td>
    <td><select name="idReservacion" id="idReservacion">
              <option>Seleccione</option>
              <?php 
				  $con = OCILogon ('SPA','1234') or die( "No se pudo conectar a la base de Datos!") or die (ocierror());				  
				  $query="SELECT *
                          FROM RESERVACION
						  ORDER BY ID_RESERVACION";     	 
 				  $sentencia = OCIParse($con, $query);	 
			      OCIExecute($sentencia);
				  
				  $rows = OCIFetchstatement($sentencia, $results);
	
    			  if ($rows > 0) {
					  for ($i = 0; $i < $rows; $i++) {
						  echo "<option value=" . $results['ID_RESERVACION'][$i] . ">" . $results['F_RESERV'][$i] . "</option>";
        			  }
    			  }				
				?>
            </select></td>
  </tr>
  
  <tr>
  <td height="36" colspan="2" align="center"><input type="submit" value="Eliminar" /></td>
  </tr>
</table>
    <p>&nbsp;</p>
  </div>
  </form>
  
  <td><font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif">
        <div align="center"><?php echo "<span class=\"textfieldRequiredMsg\">AL ELIMINAR UNA RESERVACION SE ELIMINARA AUTOMATICAMENTE TODOS LOS REGISTROS QUE LO CONTENGAN.<span>";?><font></div></td>
<!-- end #page -->

<div id="footer">
	<p> Design by <a href="http://www.freecsstemplates.org/">Nubielis, Eduardo, Daniel </a></p>
</div>
<!-- end #footer -->
</div>
</body>
</html>
